package com.twang.stock.mapper;

import com.twang.stock.dto.ZuoYeRankDTO;
import com.twang.stock.entity.ZuoYeRank;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 *
 */
public interface ZuoYeRankMapper extends Mapper<ZuoYeRank> {

    List<ZuoYeRank> querylist(String date);

    /**
     * 根据今日收益率排名
     * @param date
     * @return
     */
    List<ZuoYeRank> querylistOrderByTodayYeild(@Param("date") String date);



    List<String> queryLastDate();

    /**
     * 根据收益率排名
     * @param date
     * @return
     */
    List<ZuoYeRank> querylistByYeild(String date);


    ZuoYeRank  queryuser(@Param("userName")String userName,@Param("date")String date);

    List<ZuoYeRank>  queryByUserName(String userName);


    /**
     * 查询今日未报单数据
     * @param date
     * @return
     */
    List<ZuoYeRank> queryTodayNotUpLoad(String date);


    /**
     * 删除username，date
     * @param username
     * @param date
     * @return
     */
    int deletedData(@Param("userName") String username, @Param("date") String date);

    List<ZuoYeRankDTO> queryDownLoadlist(String date);


}
